UPDATE C1_PROVINCE SET END_DATE = SYSDATE, DATA_STATE_CODE = '0' WHERE
INSTR(','||:provinceIds||',', ','||PROVINCE_ID||',') > 0